Dataset statistics
| Number of variables | 34 |
|---|---|
| Number of observations | 95221 |
| Missing cells | 28958 |
| Missing cells (%) | 0.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 24.7 MiB |
| Average record size in memory | 272.0 B |
Variable types
| NUM | 19 |
|---|---|
| BOOL | 11 |
| CAT | 4 |
AppointmentDTS has a high cardinality: 320 distinct values | High cardinality |
AppointmentMonthNBR is highly correlated with AppointmentID | High correlation |
AppointmentID is highly correlated with AppointmentMonthNBR | High correlation |
AppttoCheckoutNBR is highly correlated with CheckintoCheckoutNBR | High correlation |
CheckintoCheckoutNBR is highly correlated with AppttoCheckoutNBR | High correlation |
Noshow24NBR has 1616 (1.7%) missing values | Missing |
CancellationsNBR has 1616 (1.7%) missing values | Missing |
Latearrivals24NBR has 1616 (1.7%) missing values | Missing |
CheckintoCheckoutNBR has 6765 (7.1%) missing values | Missing |
AppttoCheckoutNBR has 6765 (7.1%) missing values | Missing |
CheckintoApptNBR has 4116 (4.3%) missing values | Missing |
Arrived24NBR has 1616 (1.7%) missing values | Missing |
Providers24CNT has 1616 (1.7%) missing values | Missing |
ThatProvider24NBR has 1616 (1.7%) missing values | Missing |
NoshowRate24NBR has 1616 (1.7%) missing values | Missing |
EdVisitsNBR is highly skewed (γ1 = 30.76642438) | Skewed |
AppointmentID has unique values | Unique |
AgeNBR has 1632 (1.7%) zeros | Zeros |
ApptLagNBR has 22713 (23.9%) zeros | Zeros |
Noshow24NBR has 56215 (59.0%) zeros | Zeros |
CancellationsNBR has 22949 (24.1%) zeros | Zeros |
Latearrivals24NBR has 21275 (22.3%) zeros | Zeros |
CheckintoApptNBR has 5038 (5.3%) zeros | Zeros |
Arrived24NBR has 2506 (2.6%) zeros | Zeros |
Providers24CNT has 2506 (2.6%) zeros | Zeros |
ThatProvider24NBR has 24825 (26.1%) zeros | Zeros |
NoshowRate24NBR has 56215 (59.0%) zeros | Zeros |
EdVisitsNBR has 67942 (71.4%) zeros | Zeros |
IpVisitsNBR has 93510 (98.2%) zeros | Zeros |
Reproduction
| Analysis started | 2020-09-12 16:17:54.922672 |
|---|---|
| Analysis finished | 2020-09-12 16:19:14.953589 |
| Duration | 1 minute and 20.03 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 95221 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47611 |
|---|---|
| Minimum | 1 |
| Maximum | 95221 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4762 |
| Q1 | 23806 |
| median | 47611 |
| Q3 | 71416 |
| 95-th percentile | 90460 |
| Maximum | 95221 |
| Range | 95220 |
| Interquartile range (IQR) | 47610 |
Descriptive statistics
| Standard deviation | 27488.07933 |
|---|---|
| Coefficient of variation (CV) | 0.5773472376 |
| Kurtosis | -1.2 |
| Mean | 47611 |
| Median Absolute Deviation (MAD) | 23805 |
| Skewness | 4.045179012e-18 |
| Sum | 4533567031 |
| Variance | 755594505.2 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 23198 | 1 | < 0.1% | |
| 661 | 1 | < 0.1% | |
| 6806 | 1 | < 0.1% | |
| 4759 | 1 | < 0.1% | |
| 27288 | 1 | < 0.1% | |
| 25241 | 1 | < 0.1% | |
| 31386 | 1 | < 0.1% | |
| 29339 | 1 | < 0.1% | |
| 19100 | 1 | < 0.1% | |
| Other values (95211) | 95211 | > 99.9% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 95221 | 1 | < 0.1% | |
| 95220 | 1 | < 0.1% | |
| 95219 | 1 | < 0.1% | |
| 95218 | 1 | < 0.1% | |
| 95217 | 1 | < 0.1% |
PatientID
Real number (ℝ≥0)
| Distinct | 33473 |
|---|---|
| Distinct (%) | 35.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16752.13458 |
|---|---|
| Minimum | 1 |
| Maximum | 33473 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1869 |
| Q1 | 8386 |
| median | 16640 |
| Q3 | 25323 |
| 95-th percentile | 31719 |
| Maximum | 33473 |
| Range | 33472 |
| Interquartile range (IQR) | 16937 |
Descriptive statistics
| Standard deviation | 9649.346171 |
|---|---|
| Coefficient of variation (CV) | 0.5760069634 |
| Kurtosis | -1.220440449 |
| Mean | 16752.13458 |
| Median Absolute Deviation (MAD) | 8443 |
| Skewness | 0.03000413431 |
| Sum | 1595155007 |
| Variance | 93109881.53 |
| Monotocity | Increasing |
| Value | Count | Frequency (%) | |
| 663 | 56 | 0.1% | |
| 11962 | 53 | 0.1% | |
| 9152 | 32 | < 0.1% | |
| 14306 | 32 | < 0.1% | |
| 16821 | 28 | < 0.1% | |
| 9781 | 28 | < 0.1% | |
| 5092 | 27 | < 0.1% | |
| 12534 | 26 | < 0.1% | |
| 11637 | 25 | < 0.1% | |
| 9266 | 25 | < 0.1% | |
| Other values (33463) | 94889 | 99.7% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 4 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 33473 | 2 | < 0.1% | |
| 33472 | 3 | < 0.1% | |
| 33471 | 1 | < 0.1% | |
| 33470 | 1 | < 0.1% | |
| 33469 | 4 | < 0.1% |
ClinicNM
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| B | |
|---|---|
| A | |
| E | |
| C | |
| D |
| Value | Count | Frequency (%) | |
| B | 29990 | 31.5% | |
| A | 26370 | 27.7% | |
| E | 15084 | 15.8% | |
| C | 14480 | 15.2% | |
| D | 9297 | 9.8% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct | 320 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| 5/24/18 | 488 |
|---|---|
| 3/8/18 | 476 |
| 5/8/18 | 474 |
| 5/3/18 | 472 |
| 3/20/18 | 471 |
| Other values (315) |
| Value | Count | Frequency (%) | |
| 5/24/18 | 488 | 0.5% | |
| 3/8/18 | 476 | 0.5% | |
| 5/8/18 | 474 | 0.5% | |
| 5/3/18 | 472 | 0.5% | |
| 3/20/18 | 471 | 0.5% | |
| 12/19/18 | 471 | 0.5% | |
| 2/20/18 | 468 | 0.5% | |
| 11/14/18 | 468 | 0.5% | |
| 5/29/18 | 467 | 0.5% | |
| 3/1/18 | 466 | 0.5% | |
| Other values (310) | 90500 | 95.0% |
Unique
| Unique | 20 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.977736004 |
| Min length | 6 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.561451781 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 6 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.344395106 |
|---|---|
| Coefficient of variation (CV) | 0.5097035257 |
| Kurtosis | -1.207100685 |
| Mean | 6.561451781 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.0265449042 |
| Sum | 624788 |
| Variance | 11.18497863 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 5 | 9081 | 9.5% | |
| 3 | 9054 | 9.5% | |
| 8 | 8687 | 9.1% | |
| 10 | 8481 | 8.9% | |
| 4 | 8402 | 8.8% | |
| 2 | 8241 | 8.7% | |
| 11 | 8212 | 8.6% | |
| 6 | 7862 | 8.3% | |
| 9 | 7545 | 7.9% | |
| 7 | 7293 | 7.7% | |
| Other values (2) | 12363 | 13.0% |
| Value | Count | Frequency (%) | |
| 1 | 5181 | 5.4% | |
| 2 | 8241 | 8.7% | |
| 3 | 9054 | 9.5% | |
| 4 | 8402 | 8.8% | |
| 5 | 9081 | 9.5% |
| Value | Count | Frequency (%) | |
| 12 | 7182 | 7.5% | |
| 11 | 8212 | 8.6% | |
| 10 | 8481 | 8.9% | |
| 9 | 7545 | 7.9% | |
| 8 | 8687 | 9.1% |
AppointmentWeekdayNBR
Real number (ℝ≥0)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.988101364 |
|---|---|
| Minimum | 1 |
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.391332725 |
|---|---|
| Coefficient of variation (CV) | 0.3488709533 |
| Kurtosis | -1.207545006 |
| Mean | 3.988101364 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.02828131126 |
| Sum | 379751 |
| Variance | 1.935806751 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 4 | 19983 | 21.0% | |
| 5 | 19936 | 20.9% | |
| 3 | 19711 | 20.7% | |
| 2 | 18196 | 19.1% | |
| 6 | 16929 | 17.8% | |
| 7 | 429 | 0.5% | |
| 1 | 37 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 37 | < 0.1% | |
| 2 | 18196 | 19.1% | |
| 3 | 19711 | 20.7% | |
| 4 | 19983 | 21.0% | |
| 5 | 19936 | 20.9% |
| Value | Count | Frequency (%) | |
| 7 | 429 | 0.5% | |
| 6 | 16929 | 17.8% | |
| 5 | 19936 | 20.9% | |
| 4 | 19983 | 21.0% | |
| 3 | 19711 | 20.7% |
AppointmentHourNBR
Real number (ℝ≥0)
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.01135254 |
|---|---|
| Minimum | 7 |
| Maximum | 19 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 10 |
| median | 11 |
| Q3 | 14 |
| 95-th percentile | 16 |
| Maximum | 19 |
| Range | 12 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.769706516 |
|---|---|
| Coefficient of variation (CV) | 0.2305907272 |
| Kurtosis | -1.208521922 |
| Mean | 12.01135254 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.08256835547 |
| Sum | 1143733 |
| Variance | 7.671274185 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 10 | 13323 | 14.0% | |
| 9 | 13258 | 13.9% | |
| 14 | 12841 | 13.5% | |
| 15 | 12349 | 13.0% | |
| 11 | 11444 | 12.0% | |
| 13 | 10570 | 11.1% | |
| 16 | 8226 | 8.6% | |
| 8 | 8063 | 8.5% | |
| 7 | 1603 | 1.7% | |
| 17 | 1321 | 1.4% | |
| Other values (3) | 2223 | 2.3% |
| Value | Count | Frequency (%) | |
| 7 | 1603 | 1.7% | |
| 8 | 8063 | 8.5% | |
| 9 | 13258 | 13.9% | |
| 10 | 13323 | 14.0% | |
| 11 | 11444 | 12.0% |
| Value | Count | Frequency (%) | |
| 19 | 170 | 0.2% | |
| 18 | 869 | 0.9% | |
| 17 | 1321 | 1.4% | |
| 16 | 8226 | 8.6% | |
| 15 | 12349 | 13.0% |
| Distinct | 106 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.53279214 |
|---|---|
| Minimum | 0 |
| Maximum | 118 |
| Zeros | 1632 |
| Zeros (%) | 1.7% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 27 |
| median | 46 |
| Q3 | 62 |
| 95-th percentile | 80 |
| Maximum | 118 |
| Range | 118 |
| Interquartile range (IQR) | 35 |
Descriptive statistics
| Standard deviation | 22.98413032 |
|---|---|
| Coefficient of variation (CV) | 0.5161169828 |
| Kurtosis | -0.8123779807 |
| Mean | 44.53279214 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | -0.131375275 |
| Sum | 4240457 |
| Variance | 528.2702463 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 1761 | 1.8% | |
| 61 | 1635 | 1.7% | |
| 0 | 1632 | 1.7% | |
| 55 | 1610 | 1.7% | |
| 57 | 1602 | 1.7% | |
| 58 | 1584 | 1.7% | |
| 56 | 1578 | 1.7% | |
| 62 | 1567 | 1.6% | |
| 63 | 1539 | 1.6% | |
| 59 | 1495 | 1.6% | |
| Other values (96) | 79218 | 83.2% |
| Value | Count | Frequency (%) | |
| 0 | 1632 | 1.7% | |
| 1 | 1761 | 1.8% | |
| 2 | 1147 | 1.2% | |
| 3 | 618 | 0.6% | |
| 4 | 582 | 0.6% |
| Value | Count | Frequency (%) | |
| 118 | 1 | < 0.1% | |
| 110 | 4 | < 0.1% | |
| 104 | 3 | < 0.1% | |
| 103 | 1 | < 0.1% | |
| 101 | 2 | < 0.1% |
SexFLG
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| F | |
|---|---|
| M |
| Value | Count | Frequency (%) | |
| F | 57070 | 59.9% | |
| M | 38151 | 40.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
HispanicFLG
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 82888 | 87.0% | |
| 1 | 12333 | 13.0% |
SingleFLG
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 52719 | 55.4% | |
| 0 | 42502 | 44.6% |
LivesInApartmentFLG
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 76525 | 80.4% | |
| 1 | 18696 | 19.6% |
EmailFLG
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 48513 | 50.9% | |
| 1 | 46708 | 49.1% |
| Distinct | 273 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.78240094 |
|---|---|
| Minimum | 0 |
| Maximum | 546 |
| Zeros | 22713 |
| Zeros (%) | 23.9% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 7 |
| Q3 | 23 |
| 95-th percentile | 91 |
| Maximum | 546 |
| Range | 546 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 36.00486375 |
|---|---|
| Coefficient of variation (CV) | 1.820045194 |
| Kurtosis | 23.60839473 |
| Mean | 19.78240094 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 4.077167983 |
| Sum | 1883700 |
| Variance | 1296.350214 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 22713 | 23.9% | |
| 1 | 7550 | 7.9% | |
| 7 | 4038 | 4.2% | |
| 2 | 3491 | 3.7% | |
| 3 | 3439 | 3.6% | |
| 4 | 2886 | 3.0% | |
| 6 | 2794 | 2.9% | |
| 14 | 2644 | 2.8% | |
| 8 | 2447 | 2.6% | |
| 5 | 2409 | 2.5% | |
| Other values (263) | 40810 | 42.9% |
| Value | Count | Frequency (%) | |
| 0 | 22713 | 23.9% | |
| 1 | 7550 | 7.9% | |
| 2 | 3491 | 3.7% | |
| 3 | 3439 | 3.6% | |
| 4 | 2886 | 3.0% |
| Value | Count | Frequency (%) | |
| 546 | 1 | < 0.1% | |
| 399 | 1 | < 0.1% | |
| 392 | 1 | < 0.1% | |
| 384 | 1 | < 0.1% | |
| 379 | 1 | < 0.1% |
InsuranceDSC
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| Commercial | |
|---|---|
| Medicare | |
| Medicaid | |
| Self Pay |
| Value | Count | Frequency (%) | |
| Commercial | 42768 | 44.9% | |
| Medicare | 22848 | 24.0% | |
| Medicaid | 21900 | 23.0% | |
| Self Pay | 7705 | 8.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 10 |
|---|---|
| Median length | 8 |
| Mean length | 8.898289243 |
| Min length | 8 |
HypertensionFLG
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 61138 | 64.2% | |
| 1 | 34083 | 35.8% |
AsthmaFLG
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 86255 | 90.6% | |
| 1 | 8966 | 9.4% |
HeartDiseaseFLG
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 84832 | 89.1% | |
| 1 | 10389 | 10.9% |
ObeseFLG
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 70552 | 74.1% | |
| 1 | 24669 | 25.9% |
DiabetesFLG
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| 0 | |
|---|---|
| 1 | 523 |
| Value | Count | Frequency (%) | |
| 0 | 94698 | 99.5% | |
| 1 | 523 | 0.5% |
| Distinct | 38 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1616 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.15180813 |
|---|---|
| Minimum | 0 |
| Maximum | 47 |
| Zeros | 56215 |
| Zeros (%) | 59.0% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 5 |
| Maximum | 47 |
| Range | 47 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 2.466546409 |
|---|---|
| Coefficient of variation (CV) | 2.141455981 |
| Kurtosis | 31.62482131 |
| Mean | 1.15180813 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.526508446 |
| Sum | 107815 |
| Variance | 6.083851187 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 56215 | 59.0% | |
| 1 | 16525 | 17.4% | |
| 2 | 7796 | 8.2% | |
| 3 | 4296 | 4.5% | |
| 4 | 2520 | 2.6% | |
| 5 | 1579 | 1.7% | |
| 6 | 1215 | 1.3% | |
| 7 | 850 | 0.9% | |
| 8 | 560 | 0.6% | |
| 9 | 404 | 0.4% | |
| Other values (28) | 1645 | 1.7% | |
| (Missing) | 1616 | 1.7% |
| Value | Count | Frequency (%) | |
| 0 | 56215 | 59.0% | |
| 1 | 16525 | 17.4% | |
| 2 | 7796 | 8.2% | |
| 3 | 4296 | 4.5% | |
| 4 | 2520 | 2.6% |
| Value | Count | Frequency (%) | |
| 47 | 3 | < 0.1% | |
| 45 | 1 | < 0.1% | |
| 43 | 1 | < 0.1% | |
| 34 | 1 | < 0.1% | |
| 33 | 3 | < 0.1% |
| Distinct | 174 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1616 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.9391165 |
|---|---|
| Minimum | 0 |
| Maximum | 604 |
| Zeros | 22949 |
| Zeros (%) | 24.1% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 18 |
| Maximum | 604 |
| Range | 604 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 11.0809564 |
|---|---|
| Coefficient of variation (CV) | 2.243509827 |
| Kurtosis | 535.2164223 |
| Mean | 4.9391165 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 14.99097015 |
| Sum | 462326 |
| Variance | 122.7875948 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 22949 | 24.1% | |
| 1 | 16623 | 17.5% | |
| 2 | 11794 | 12.4% | |
| 3 | 8473 | 8.9% | |
| 4 | 6241 | 6.6% | |
| 5 | 4780 | 5.0% | |
| 6 | 3522 | 3.7% | |
| 7 | 2759 | 2.9% | |
| 8 | 2264 | 2.4% | |
| 9 | 1858 | 2.0% | |
| Other values (164) | 12342 | 13.0% | |
| (Missing) | 1616 | 1.7% |
| Value | Count | Frequency (%) | |
| 0 | 22949 | 24.1% | |
| 1 | 16623 | 17.5% | |
| 2 | 11794 | 12.4% | |
| 3 | 8473 | 8.9% | |
| 4 | 6241 | 6.6% |
| Value | Count | Frequency (%) | |
| 604 | 2 | < 0.1% | |
| 603 | 2 | < 0.1% | |
| 537 | 1 | < 0.1% | |
| 425 | 1 | < 0.1% | |
| 382 | 1 | < 0.1% |
| Distinct | 101 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1616 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.863960259 |
|---|---|
| Minimum | 0 |
| Maximum | 130 |
| Zeros | 21275 |
| Zeros (%) | 22.3% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 14 |
| Maximum | 130 |
| Range | 130 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 6.482212343 |
|---|---|
| Coefficient of variation (CV) | 1.67760844 |
| Kurtosis | 48.48044112 |
| Mean | 3.863960259 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 5.427877776 |
| Sum | 361686 |
| Variance | 42.01907685 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 21275 | 22.3% | |
| 1 | 19297 | 20.3% | |
| 2 | 13083 | 13.7% | |
| 3 | 9368 | 9.8% | |
| 4 | 6840 | 7.2% | |
| 5 | 4880 | 5.1% | |
| 6 | 3755 | 3.9% | |
| 7 | 2766 | 2.9% | |
| 8 | 2080 | 2.2% | |
| 9 | 1516 | 1.6% | |
| Other values (91) | 8745 | 9.2% | |
| (Missing) | 1616 | 1.7% |
| Value | Count | Frequency (%) | |
| 0 | 21275 | 22.3% | |
| 1 | 19297 | 20.3% | |
| 2 | 13083 | 13.7% | |
| 3 | 9368 | 9.8% | |
| 4 | 6840 | 7.2% |
| Value | Count | Frequency (%) | |
| 130 | 1 | < 0.1% | |
| 129 | 1 | < 0.1% | |
| 128 | 1 | < 0.1% | |
| 122 | 1 | < 0.1% | |
| 120 | 1 | < 0.1% |
| Distinct | 852 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 6765 |
| Missing (%) | 7.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50.27244054 |
|---|---|
| Minimum | -911 |
| Maximum | 596 |
| Zeros | 231 |
| Zeros (%) | 0.2% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | -911 |
|---|---|
| 5-th percentile | -63 |
| Q1 | 39 |
| median | 56 |
| Q3 | 75 |
| 95-th percentile | 128 |
| Maximum | 596 |
| Range | 1507 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 69.44975345 |
|---|---|
| Coefficient of variation (CV) | 1.381467713 |
| Kurtosis | 16.50842071 |
| Mean | 50.27244054 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | -2.346794046 |
| Sum | 4446899 |
| Variance | 4823.268255 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 50 | 1464 | 1.5% | |
| 57 | 1446 | 1.5% | |
| 56 | 1417 | 1.5% | |
| 53 | 1415 | 1.5% | |
| 55 | 1410 | 1.5% | |
| 48 | 1410 | 1.5% | |
| 49 | 1405 | 1.5% | |
| 54 | 1396 | 1.5% | |
| 47 | 1395 | 1.5% | |
| 58 | 1384 | 1.5% | |
| Other values (842) | 74314 | 78.0% | |
| (Missing) | 6765 | 7.1% |
| Value | Count | Frequency (%) | |
| -911 | 3 | < 0.1% | |
| -840 | 1 | < 0.1% | |
| -749 | 3 | < 0.1% | |
| -747 | 1 | < 0.1% | |
| -708 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 596 | 1 | < 0.1% | |
| 588 | 2 | < 0.1% | |
| 566 | 1 | < 0.1% | |
| 548 | 1 | < 0.1% | |
| 528 | 1 | < 0.1% |
| Distinct | 940 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 6765 |
| Missing (%) | 7.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42.3217871 |
|---|---|
| Minimum | -933 |
| Maximum | 768 |
| Zeros | 248 |
| Zeros (%) | 0.3% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | -933 |
|---|---|
| 5-th percentile | -75 |
| Q1 | 31 |
| median | 48 |
| Q3 | 67 |
| 95-th percentile | 123 |
| Maximum | 768 |
| Range | 1701 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 72.89260552 |
|---|---|
| Coefficient of variation (CV) | 1.722342333 |
| Kurtosis | 16.39418989 |
| Mean | 42.3217871 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | -1.940641188 |
| Sum | 3743616 |
| Variance | 5313.331939 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 44 | 1456 | 1.5% | |
| 50 | 1445 | 1.5% | |
| 46 | 1410 | 1.5% | |
| 41 | 1405 | 1.5% | |
| 43 | 1393 | 1.5% | |
| 45 | 1364 | 1.4% | |
| 42 | 1362 | 1.4% | |
| 39 | 1361 | 1.4% | |
| 48 | 1356 | 1.4% | |
| 37 | 1353 | 1.4% | |
| Other values (930) | 74551 | 78.3% | |
| (Missing) | 6765 | 7.1% |
| Value | Count | Frequency (%) | |
| -933 | 3 | < 0.1% | |
| -905 | 1 | < 0.1% | |
| -819 | 2 | < 0.1% | |
| -762 | 3 | < 0.1% | |
| -741 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 768 | 1 | < 0.1% | |
| 657 | 2 | < 0.1% | |
| 645 | 1 | < 0.1% | |
| 586 | 1 | < 0.1% | |
| 578 | 1 | < 0.1% |
| Distinct | 406 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 4116 |
| Missing (%) | 4.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.913780802 |
|---|---|
| Minimum | -958 |
| Maximum | 656 |
| Zeros | 5038 |
| Zeros (%) | 5.3% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | -958 |
|---|---|
| 5-th percentile | -9 |
| Q1 | 2 |
| median | 7 |
| Q3 | 13 |
| 95-th percentile | 27 |
| Maximum | 656 |
| Range | 1614 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 21.2410614 |
|---|---|
| Coefficient of variation (CV) | 3.072278687 |
| Kurtosis | 284.162105 |
| Mean | 6.913780802 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -10.72325705 |
| Sum | 629880 |
| Variance | 451.1826895 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 5038 | 5.3% | |
| 6 | 4674 | 4.9% | |
| 5 | 4610 | 4.8% | |
| 4 | 4584 | 4.8% | |
| 3 | 4393 | 4.6% | |
| 7 | 4303 | 4.5% | |
| 8 | 4157 | 4.4% | |
| 2 | 4093 | 4.3% | |
| 9 | 3952 | 4.2% | |
| 10 | 3730 | 3.9% | |
| Other values (396) | 47571 | 50.0% | |
| (Missing) | 4116 | 4.3% |
| Value | Count | Frequency (%) | |
| -958 | 1 | < 0.1% | |
| -951 | 1 | < 0.1% | |
| -727 | 1 | < 0.1% | |
| -716 | 1 | < 0.1% | |
| -528 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 656 | 1 | < 0.1% | |
| 433 | 1 | < 0.1% | |
| 270 | 1 | < 0.1% | |
| 244 | 2 | < 0.1% | |
| 219 | 2 | < 0.1% |
| Distinct | 190 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1616 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.98278938 |
|---|---|
| Minimum | 0 |
| Maximum | 276 |
| Zeros | 2506 |
| Zeros (%) | 2.6% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 9 |
| Q3 | 18 |
| 95-th percentile | 45 |
| Maximum | 276 |
| Range | 276 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 16.27616093 |
|---|---|
| Coefficient of variation (CV) | 1.164013881 |
| Kurtosis | 21.75992182 |
| Mean | 13.98278938 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 3.406373969 |
| Sum | 1308859 |
| Variance | 264.9134147 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 3 | 6065 | 6.4% | |
| 4 | 6041 | 6.3% | |
| 5 | 5840 | 6.1% | |
| 2 | 5685 | 6.0% | |
| 6 | 5203 | 5.5% | |
| 1 | 5161 | 5.4% | |
| 7 | 4694 | 4.9% | |
| 8 | 4427 | 4.6% | |
| 9 | 4006 | 4.2% | |
| 10 | 3527 | 3.7% | |
| Other values (180) | 42956 | 45.1% |
| Value | Count | Frequency (%) | |
| 0 | 2506 | 2.6% | |
| 1 | 5161 | 5.4% | |
| 2 | 5685 | 6.0% | |
| 3 | 6065 | 6.4% | |
| 4 | 6041 | 6.3% |
| Value | Count | Frequency (%) | |
| 276 | 1 | < 0.1% | |
| 271 | 2 | < 0.1% | |
| 269 | 1 | < 0.1% | |
| 267 | 1 | < 0.1% | |
| 236 | 1 | < 0.1% |
| Distinct | 55 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1616 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.281651621 |
|---|---|
| Minimum | 0 |
| Maximum | 57 |
| Zeros | 2506 |
| Zeros (%) | 2.6% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 18 |
| Maximum | 57 |
| Range | 57 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 5.572235754 |
|---|---|
| Coefficient of variation (CV) | 0.8870653914 |
| Kurtosis | 4.512995795 |
| Mean | 6.281651621 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.793217685 |
| Sum | 587994 |
| Variance | 31.0498113 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2 | 11892 | 12.5% | |
| 3 | 10964 | 11.5% | |
| 1 | 10876 | 11.4% | |
| 4 | 9600 | 10.1% | |
| 5 | 8167 | 8.6% | |
| 6 | 6532 | 6.9% | |
| 7 | 5378 | 5.6% | |
| 8 | 4368 | 4.6% | |
| 9 | 3694 | 3.9% | |
| 10 | 3035 | 3.2% | |
| Other values (45) | 19099 | 20.1% |
| Value | Count | Frequency (%) | |
| 0 | 2506 | 2.6% | |
| 1 | 10876 | 11.4% | |
| 2 | 11892 | 12.5% | |
| 3 | 10964 | 11.5% | |
| 4 | 9600 | 10.1% |
| Value | Count | Frequency (%) | |
| 57 | 1 | < 0.1% | |
| 56 | 1 | < 0.1% | |
| 53 | 5 | < 0.1% | |
| 52 | 2 | < 0.1% | |
| 51 | 6 | < 0.1% |
| Distinct | 272 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 1616 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.92156402 |
|---|---|
| Minimum | 0 |
| Maximum | 383 |
| Zeros | 24825 |
| Zeros (%) | 26.1% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 6 |
| Q3 | 21 |
| 95-th percentile | 64 |
| Maximum | 383 |
| Range | 383 |
| Interquartile range (IQR) | 21 |
Descriptive statistics
| Standard deviation | 25.22748264 |
|---|---|
| Coefficient of variation (CV) | 1.584485206 |
| Kurtosis | 20.84035885 |
| Mean | 15.92156402 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 3.54510997 |
| Sum | 1490338 |
| Variance | 636.4258806 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 24825 | 26.1% | |
| 2 | 5697 | 6.0% | |
| 1 | 4655 | 4.9% | |
| 3 | 3388 | 3.6% | |
| 4 | 3366 | 3.5% | |
| 5 | 2692 | 2.8% | |
| 6 | 2600 | 2.7% | |
| 7 | 2363 | 2.5% | |
| 8 | 2187 | 2.3% | |
| 9 | 2011 | 2.1% | |
| Other values (262) | 39821 | 41.8% |
| Value | Count | Frequency (%) | |
| 0 | 24825 | 26.1% | |
| 1 | 4655 | 4.9% | |
| 2 | 5697 | 6.0% | |
| 3 | 3388 | 3.6% | |
| 4 | 3366 | 3.5% |
| Value | Count | Frequency (%) | |
| 383 | 2 | < 0.1% | |
| 381 | 1 | < 0.1% | |
| 380 | 1 | < 0.1% | |
| 367 | 1 | < 0.1% | |
| 289 | 3 | < 0.1% |
| Distinct | 1054 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 1616 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07126754929 |
|---|---|
| Minimum | 0 |
| Maximum | 1 |
| Zeros | 56215 |
| Zeros (%) | 59.0% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.1 |
| 95-th percentile | 0.333333 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.1 |
Descriptive statistics
| Standard deviation | 0.1316014542 |
|---|---|
| Coefficient of variation (CV) | 1.846583129 |
| Kurtosis | 11.80492712 |
| Mean | 0.07126754929 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.919739412 |
| Sum | 6670.998951 |
| Variance | 0.01731894274 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 56215 | 59.0% | |
| 0.2 | 1670 | 1.8% | |
| 0.25 | 1651 | 1.7% | |
| 0.333333 | 1568 | 1.6% | |
| 0.166666 | 1496 | 1.6% | |
| 0.142857 | 1421 | 1.5% | |
| 0.125 | 1277 | 1.3% | |
| 0.111111 | 1247 | 1.3% | |
| 0.5 | 1112 | 1.2% | |
| 0.1 | 1078 | 1.1% | |
| Other values (1044) | 24870 | 26.1% | |
| (Missing) | 1616 | 1.7% |
| Value | Count | Frequency (%) | |
| 0 | 56215 | 59.0% | |
| 0.00361 | 1 | < 0.1% | |
| 0.003676 | 1 | < 0.1% | |
| 0.006134 | 1 | < 0.1% | |
| 0.006211 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 341 | 0.4% | |
| 0.875 | 1 | < 0.1% | |
| 0.857142 | 2 | < 0.1% | |
| 0.833333 | 9 | < 0.1% | |
| 0.818181 | 2 | < 0.1% |
| Distinct | 45 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.649426072 |
|---|---|
| Minimum | 0 |
| Maximum | 155 |
| Zeros | 67942 |
| Zeros (%) | 71.4% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 155 |
| Range | 155 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 2.271322781 |
|---|---|
| Coefficient of variation (CV) | 3.497430853 |
| Kurtosis | 1785.144056 |
| Mean | 0.649426072 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 30.76642438 |
| Sum | 61839 |
| Variance | 5.158907174 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 67942 | 71.4% | |
| 1 | 14802 | 15.5% | |
| 2 | 5785 | 6.1% | |
| 3 | 2863 | 3.0% | |
| 4 | 1438 | 1.5% | |
| 5 | 748 | 0.8% | |
| 6 | 416 | 0.4% | |
| 7 | 364 | 0.4% | |
| 8 | 231 | 0.2% | |
| 9 | 147 | 0.2% | |
| Other values (35) | 485 | 0.5% |
| Value | Count | Frequency (%) | |
| 0 | 67942 | 71.4% | |
| 1 | 14802 | 15.5% | |
| 2 | 5785 | 6.1% | |
| 3 | 2863 | 3.0% | |
| 4 | 1438 | 1.5% |
| Value | Count | Frequency (%) | |
| 155 | 3 | < 0.1% | |
| 154 | 1 | < 0.1% | |
| 149 | 2 | < 0.1% | |
| 143 | 1 | < 0.1% | |
| 142 | 1 | < 0.1% |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.02110878903 |
|---|---|
| Minimum | 0 |
| Maximum | 6 |
| Zeros | 93510 |
| Zeros (%) | 98.2% |
| Memory size | 743.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1720177931 |
|---|---|
| Coefficient of variation (CV) | 8.149107599 |
| Kurtosis | 186.7435383 |
| Mean | 0.02110878903 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.29173591 |
| Sum | 2010 |
| Variance | 0.02959012113 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 93510 | 98.2% | |
| 1 | 1497 | 1.6% | |
| 2 | 158 | 0.2% | |
| 3 | 36 | < 0.1% | |
| 4 | 14 | < 0.1% | |
| 6 | 3 | < 0.1% | |
| 5 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 93510 | 98.2% | |
| 1 | 1497 | 1.6% | |
| 2 | 158 | 0.2% | |
| 3 | 36 | < 0.1% | |
| 4 | 14 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6 | 3 | < 0.1% | |
| 5 | 3 | < 0.1% | |
| 4 | 14 | < 0.1% | |
| 3 | 36 | < 0.1% | |
| 2 | 158 | 0.2% |
NoShowFLG
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 86115 | 90.4% | |
| 1 | 9106 | 9.6% |
CancelledLateFLG
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 743.9 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 80000 | 84.0% | |
| 1 | 15221 | 16.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| AppointmentID | PatientID | ClinicNM | AppointmentDTS | AppointmentMonthNBR | AppointmentWeekdayNBR | AppointmentHourNBR | AgeNBR | SexFLG | HispanicFLG | SingleFLG | LivesInApartmentFLG | EmailFLG | ApptLagNBR | InsuranceDSC | HypertensionFLG | AsthmaFLG | HeartDiseaseFLG | ObeseFLG | DiabetesFLG | Noshow24NBR | CancellationsNBR | Latearrivals24NBR | CheckintoCheckoutNBR | AppttoCheckoutNBR | CheckintoApptNBR | Arrived24NBR | Providers24CNT | ThatProvider24NBR | NoshowRate24NBR | EdVisitsNBR | IpVisitsNBR | NoShowFLG | CancelledLateFLG | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 21725 | 1 | E | 4/10/18 | 4 | 3 | 17 | 50 | F | 0 | 1 | 1 | 0 | 32 | Commercial | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 1.0 | 49.0 | 50.0 | -1.0 | 2.0 | 2.0 | 0.0 | 0.0 | 0 | 0 | 1 | 0 |
| 1 | 11206 | 2 | A | 2/7/18 | 2 | 4 | 10 | 80 | M | 0 | 0 | 0 | 0 | 2 | Medicare | 1 | 0 | 0 | 1 | 0 | 0.0 | 0.0 | 1.0 | 50.0 | 49.0 | 1.0 | 2.0 | 1.0 | 5.0 | 0.0 | 0 | 0 | 0 | 1 |
| 2 | 12548 | 2 | A | 2/8/18 | 2 | 5 | 16 | 80 | M | 0 | 0 | 0 | 0 | 0 | Medicare | 1 | 0 | 0 | 1 | 0 | 0.0 | 1.0 | 1.0 | 50.0 | 49.0 | 1.0 | 2.0 | 1.0 | 6.0 | 0.0 | 0 | 0 | 0 | 0 |
| 3 | 12727 | 2 | A | 3/8/18 | 3 | 5 | 15 | 80 | M | 0 | 0 | 0 | 0 | 28 | Medicare | 1 | 0 | 0 | 1 | 0 | 0.0 | 1.0 | 1.0 | 55.0 | 48.0 | 7.0 | 3.0 | 1.0 | 8.0 | 0.0 | 0 | 0 | 0 | 0 |
| 4 | 86882 | 2 | A | 11/9/18 | 11 | 6 | 16 | 80 | M | 0 | 0 | 0 | 0 | 0 | Medicare | 1 | 0 | 0 | 1 | 0 | 0.0 | 1.0 | 0.0 | 61.0 | 47.0 | 13.0 | 3.0 | 1.0 | 13.0 | 0.0 | 0 | 0 | 0 | 0 |
| 5 | 95113 | 3 | A | 12/28/18 | 12 | 6 | 15 | 32 | F | 0 | 1 | 0 | 1 | 1 | Commercial | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 1.0 | 47.0 | 45.0 | 2.0 | 3.0 | 3.0 | 11.0 | 0.0 | 0 | 0 | 0 | 0 |
| 6 | 56930 | 3 | A | 8/3/18 | 8 | 6 | 15 | 32 | F | 0 | 1 | 0 | 1 | 18 | Commercial | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 1.0 | 111.0 | 115.0 | -3.0 | 2.0 | 2.0 | 13.0 | 0.0 | 0 | 0 | 0 | 0 |
| 7 | 19704 | 4 | A | 3/5/18 | 3 | 2 | 16 | 37 | F | 0 | 1 | 0 | 0 | 0 | Commercial | 0 | 0 | 0 | 0 | 0 | 1.0 | 1.0 | 1.0 | 58.0 | 43.0 | 8.0 | 4.0 | 4.0 | 11.0 | 0.2 | 0 | 0 | 0 | 0 |
| 8 | 29351 | 5 | C | 4/5/18 | 4 | 5 | 10 | 23 | F | 0 | 0 | 1 | 0 | 0 | Medicaid | 0 | 0 | 0 | 0 | 0 | 0.0 | 12.0 | 4.0 | 75.0 | 65.0 | 10.0 | 27.0 | 17.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 |
| 9 | 92214 | 6 | B | 12/7/18 | 12 | 6 | 14 | 33 | M | 1 | 1 | 0 | 0 | 2 | Self Pay | 0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | NaN | NaN | NaN | 0.0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0 |
Last rows
| AppointmentID | PatientID | ClinicNM | AppointmentDTS | AppointmentMonthNBR | AppointmentWeekdayNBR | AppointmentHourNBR | AgeNBR | SexFLG | HispanicFLG | SingleFLG | LivesInApartmentFLG | EmailFLG | ApptLagNBR | InsuranceDSC | HypertensionFLG | AsthmaFLG | HeartDiseaseFLG | ObeseFLG | DiabetesFLG | Noshow24NBR | CancellationsNBR | Latearrivals24NBR | CheckintoCheckoutNBR | AppttoCheckoutNBR | CheckintoApptNBR | Arrived24NBR | Providers24CNT | ThatProvider24NBR | NoshowRate24NBR | EdVisitsNBR | IpVisitsNBR | NoShowFLG | CancelledLateFLG | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 95211 | 83889 | 33469 | E | 10/30/18 | 10 | 3 | 11 | 65 | F | 0 | 1 | 0 | 1 | 1 | Commercial | 0 | 0 | 0 | 0 | 0 | 0.0 | 1.0 | 1.0 | 129.0 | 124.0 | 5.0 | 4.0 | 3.0 | 5.0 | 0.000000 | 0 | 0 | 0 | 1 |
| 95212 | 83896 | 33469 | E | 10/30/18 | 10 | 3 | 14 | 65 | F | 0 | 1 | 0 | 1 | 1 | Commercial | 0 | 0 | 0 | 0 | 0 | 0.0 | 1.0 | 1.0 | 129.0 | 124.0 | 5.0 | 4.0 | 3.0 | 5.0 | 0.000000 | 0 | 0 | 0 | 0 |
| 95213 | 90497 | 33469 | E | 12/10/18 | 12 | 2 | 9 | 65 | F | 0 | 1 | 0 | 1 | 13 | Commercial | 0 | 0 | 0 | 0 | 0 | 0.0 | 2.0 | 1.0 | 111.0 | 104.0 | 7.0 | 5.0 | 3.0 | 9.0 | 0.000000 | 0 | 0 | 0 | 0 |
| 95214 | 23040 | 33470 | A | 3/15/18 | 3 | 5 | 16 | 24 | M | 0 | 1 | 0 | 1 | 1 | Commercial | 0 | 1 | 0 | 0 | 0 | 1.0 | 1.0 | 2.0 | 47.0 | 54.0 | -6.0 | 2.0 | 1.0 | 6.0 | 0.333333 | 0 | 0 | 0 | 0 |
| 95215 | 53297 | 33471 | A | 7/3/18 | 7 | 3 | 14 | 83 | F | 0 | 1 | 1 | 0 | 1 | Medicare | 0 | 0 | 0 | 0 | 0 | 0.0 | 1.0 | 0.0 | 60.0 | 52.0 | 8.0 | 5.0 | 2.0 | 16.0 | 0.000000 | 0 | 0 | 0 | 0 |
| 95216 | 20483 | 33472 | A | 3/21/18 | 3 | 4 | 7 | 38 | F | 0 | 0 | 1 | 0 | 15 | Commercial | 0 | 0 | 0 | 0 | 0 | 0.0 | 1.0 | 0.0 | 52.0 | 47.0 | 5.0 | 4.0 | 3.0 | 7.0 | 0.000000 | 0 | 0 | 0 | 0 |
| 95217 | 81514 | 33472 | A | 10/19/18 | 10 | 6 | 8 | 38 | F | 0 | 0 | 1 | 0 | 1 | Commercial | 0 | 0 | 0 | 0 | 0 | 0.0 | 2.0 | 0.0 | 50.0 | 44.0 | 6.0 | 4.0 | 2.0 | 0.0 | 0.000000 | 0 | 0 | 1 | 0 |
| 95218 | 81507 | 33472 | A | 10/18/18 | 10 | 5 | 11 | 38 | F | 0 | 0 | 1 | 0 | 0 | Commercial | 0 | 0 | 0 | 0 | 0 | 0.0 | 1.0 | 0.0 | 50.0 | 44.0 | 6.0 | 4.0 | 2.0 | 0.0 | 0.000000 | 0 | 0 | 0 | 1 |
| 95219 | 1763 | 33473 | A | 6/5/18 | 6 | 3 | 8 | 40 | M | 0 | 1 | 0 | 1 | 182 | Commercial | 1 | 0 | 0 | 0 | 0 | 0.0 | 3.0 | 0.0 | 45.0 | 32.0 | 13.0 | 5.0 | 1.0 | 17.0 | 0.000000 | 0 | 0 | 0 | 0 |
| 95220 | 46027 | 33473 | A | 12/18/18 | 12 | 3 | 8 | 40 | M | 0 | 1 | 0 | 1 | 196 | Commercial | 1 | 0 | 0 | 0 | 0 | 0.0 | 1.0 | 0.0 | 53.0 | 44.0 | 8.0 | 4.0 | 2.0 | 11.0 | 0.000000 | 0 | 0 | 0 | 0 |